Technical Overview
The primary design element of BI Blend are the BI Blend Settings found on the Workflow Import Channel by Scenario Type. These settings allow the BI Blend administrator to define and optimize the generation BI Blend tables to meet the reporting requirements.
|
Setting |
Function |
|---|---|
|
Measure Type |
Defines how the time dimension column will be determined in the relational tables. |
|
Content Type |
Controls the type and level of detail displayed in the relational tables for base level records only (analysis of source against aggregated parents is not supported). The designer controls how the BI Blend tables utilizes dimension hierarchies and the inclusion of Attributes related to the Cube Integration Settings. |
|
Create Star Schema (Optional) |
Creates the output as a Star Schema table set and related Views. Supporting Dimension tables will be created for each Cube Dimension assigned an Aggregation Control. The Dimension tables will contain column fields for MemberName, MemberDesc, NameAndDesc, ParentName, IndentLevel, IsBaseand MemberSeq, which can be used in reporting against the Star Schema view. This is an optional setting. |
|
DB Location |
Sets the name of the SQL Database that holds the BI Blend results tables. |
|
Explosion Adjustor |
Estimates the size of tables generated, as derived from the initial Learning Mode. |
|
Column Alias |
Defines custom column names for the output database table. Spaces in the names are not recommended. Use underscores to represent spaces. |
|
Translate |
Enables translation to a single destination currency. |
|
Blend Unit Token |
Token to assign a Dimension to partition as a Page Dimension and the basis of the BI Blend multi-threading. |
|
Dimension Aggregation |
Parent member point to set top level aggregation member. Can be set as a parent level, children, list, distinct member or no aggregation. |
|
Max Degree Non SQL Parallelism |
The default setting is 8. |
|
Max Degree SQL Parallelism |
The default setting is 4. |
|
Row Limit |
Estimated by analyzing the Blend Log File, base level rows, and the Explosion factor to determine free memory usage. |
|
Shrink After Finalize |
Compacts the BI Blend database upon table finalization. The default setting is “True”. |
|
Application Servers |
The BI Blend processes default to the Stage Servers, with queuing controls. This can be overridden with named servers. |
